<?php
	
	include("connection_mysqli.php");
	$req=$connexion->prepare('SELECT address,city,name,slogan,BP FROM Store ORDER BY dateinscription DESC LIMIT 0,4');
	$result=$req->execute();
	$req->bind_result($col1,$col2,$col3,$col4,$col5);
	
	if (!$req) {
		die('Could not query'.mysql_error());
		echo("fail !req");
	}
	echo('<div id = newsdiv>');
	echo('<ul id="newsmenu" >');
		echo('<div class="head">Nouveaux magasins</div>');
		while ($donnees = $req->fetch()){
			echo('<li><table class="table" border=0>');
			echo('<tr><td>'.$col3.' - '.stripcslashes($col4).'</td></tr>
				  <tr><td>'.$col1.'</td></tr>
				  <tr><td>'.$col5.' '.$col2.'</td></tr>');
			echo('</table></li>');
		}
	echo('<div class="last"> </div></ul>');	
	echo('</div>');	
	$req->close();
	$connexion->close();
?>